--DO NOT MODIFY THIS FILE. IT IS ALWAYS OVERWRITTEN ON GENERATION.
--Audit Triggers For Version 1.0.0.0

--##SECTION BEGIN [AUDIT TRIGGERS]

--DROP ANY AUDIT TRIGGERS FOR [dbo].[Administrator]
if exists(select * from sysobjects where name = '__TR_Administrator__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Administrator__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_Administrator__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Administrator__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_Administrator__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Administrator__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[BodyType]
if exists(select * from sysobjects where name = '__TR_BodyType__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_BodyType__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_BodyType__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_BodyType__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_BodyType__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_BodyType__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[BulletPoint]
if exists(select * from sysobjects where name = '__TR_BulletPoint__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_BulletPoint__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_BulletPoint__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_BulletPoint__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_BulletPoint__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_BulletPoint__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[City]
if exists(select * from sysobjects where name = '__TR_City__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_City__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_City__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_City__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_City__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_City__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[CityZip]
if exists(select * from sysobjects where name = '__TR_CityZip__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_CityZip__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_CityZip__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_CityZip__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_CityZip__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_CityZip__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[Color]
if exists(select * from sysobjects where name = '__TR_Color__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Color__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_Color__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Color__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_Color__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Color__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[Condition]
if exists(select * from sysobjects where name = '__TR_Condition__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Condition__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_Condition__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Condition__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_Condition__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Condition__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[ConfigSetting]
if exists(select * from sysobjects where name = '__TR_ConfigSetting__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ConfigSetting__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_ConfigSetting__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ConfigSetting__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_ConfigSetting__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ConfigSetting__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[Dealer]
if exists(select * from sysobjects where name = '__TR_Dealer__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Dealer__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_Dealer__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Dealer__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_Dealer__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Dealer__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[Feature]
if exists(select * from sysobjects where name = '__TR_Feature__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Feature__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_Feature__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Feature__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_Feature__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Feature__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[FuelType]
if exists(select * from sysobjects where name = '__TR_FuelType__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_FuelType__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_FuelType__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_FuelType__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_FuelType__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_FuelType__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[Listing]
if exists(select * from sysobjects where name = '__TR_Listing__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Listing__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_Listing__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Listing__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_Listing__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Listing__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[ListingFeature]
if exists(select * from sysobjects where name = '__TR_ListingFeature__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ListingFeature__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_ListingFeature__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ListingFeature__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_ListingFeature__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ListingFeature__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[ListingImage]
if exists(select * from sysobjects where name = '__TR_ListingImage__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ListingImage__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_ListingImage__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ListingImage__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_ListingImage__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ListingImage__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[ListingPremium]
if exists(select * from sysobjects where name = '__TR_ListingPremium__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ListingPremium__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_ListingPremium__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ListingPremium__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_ListingPremium__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ListingPremium__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[ListingSaved]
if exists(select * from sysobjects where name = '__TR_ListingSaved__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ListingSaved__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_ListingSaved__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ListingSaved__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_ListingSaved__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ListingSaved__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[ListingView]
if exists(select * from sysobjects where name = '__TR_ListingView__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ListingView__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_ListingView__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ListingView__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_ListingView__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_ListingView__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[Make]
if exists(select * from sysobjects where name = '__TR_Make__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Make__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_Make__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Make__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_Make__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Make__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[MakeModel]
if exists(select * from sysobjects where name = '__TR_MakeModel__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_MakeModel__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_MakeModel__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_MakeModel__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_MakeModel__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_MakeModel__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[Metro]
if exists(select * from sysobjects where name = '__TR_Metro__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Metro__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_Metro__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Metro__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_Metro__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Metro__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[MetroState]
if exists(select * from sysobjects where name = '__TR_MetroState__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_MetroState__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_MetroState__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_MetroState__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_MetroState__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_MetroState__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[MetroZip]
if exists(select * from sysobjects where name = '__TR_MetroZip__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_MetroZip__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_MetroZip__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_MetroZip__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_MetroZip__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_MetroZip__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[Model]
if exists(select * from sysobjects where name = '__TR_Model__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Model__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_Model__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Model__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_Model__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Model__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[SearchSaved]
if exists(select * from sysobjects where name = '__TR_SearchSaved__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_SearchSaved__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_SearchSaved__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_SearchSaved__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_SearchSaved__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_SearchSaved__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[SearchSavedCriteria]
if exists(select * from sysobjects where name = '__TR_SearchSavedCriteria__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_SearchSavedCriteria__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_SearchSavedCriteria__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_SearchSavedCriteria__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_SearchSavedCriteria__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_SearchSavedCriteria__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[State]
if exists(select * from sysobjects where name = '__TR_State__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_State__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_State__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_State__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_State__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_State__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[Transmission]
if exists(select * from sysobjects where name = '__TR_Transmission__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Transmission__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_Transmission__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Transmission__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_Transmission__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Transmission__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[UserAccount]
if exists(select * from sysobjects where name = '__TR_UserAccount__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_UserAccount__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_UserAccount__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_UserAccount__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_UserAccount__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_UserAccount__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[UserLoginHistory]
if exists(select * from sysobjects where name = '__TR_UserLoginHistory__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_UserLoginHistory__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_UserLoginHistory__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_UserLoginHistory__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_UserLoginHistory__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_UserLoginHistory__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[UserType]
if exists(select * from sysobjects where name = '__TR_UserType__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_UserType__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_UserType__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_UserType__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_UserType__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_UserType__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[VistorContact]
if exists(select * from sysobjects where name = '__TR_VistorContact__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_VistorContact__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_VistorContact__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_VistorContact__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_VistorContact__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_VistorContact__DELETE]
GO

--DROP ANY AUDIT TRIGGERS FOR [dbo].[Zip]
if exists(select * from sysobjects where name = '__TR_Zip__INSERT' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Zip__INSERT]
GO
if exists(select * from sysobjects where name = '__TR_Zip__UPDATE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Zip__UPDATE]
GO
if exists(select * from sysobjects where name = '__TR_Zip__DELETE' AND xtype = 'TR')
DROP TRIGGER [dbo].[__TR_Zip__DELETE]
GO

--##SECTION END [AUDIT TRIGGERS]

